<?php
$dsn = "sqlsrv:Server=localhost;Database=Student";
$db = new PDO($dsn, "sa", "123456");




?>
<!DOCTYPE html>
<html lang="en">
	<head>
		<meta charset="UTF-8">
		<title>列表</title>
		<link rel="stylesheet" type="text/css" href="ui/css/main.css" />
	</head>
	<body>
		<div id="container">
			<a id="add" href="add.html">增加</a>
			<table class="list">
				<tr>
					<th>班级id</th>
					<th>班级名称</th>
					<th>操作</th>
				</tr>
                <?php foreach ($result as $key=>$value) ?>
				<tr>
					<td><?php echo ($value['ClassId']) ?></td>
					<td><?php echo ($value['ClassName']) ?></td>
					<td>
						<a href="update.html">修改</a>
						<a href="#">删除</a>
					</td>
				</tr>
			</table>
		</div>
	</body>
</html>
